class CreateBikeProps < ActiveRecord::Migration[5.0]
  def change
    create_table :bike_props do |t|
      t.integer :bike_id, comment: "车辆关联编号"
      t.string :brand, comment: "车辆品牌"
      t.string :vin, comment: "车架号"
      t.string :purchasePrice, comment: "购买价格"
      t.string :insurance, comment: "是否已买保险"
      t.string :color, comment: "颜色"
      t.string :purchaseDate, comment: "购买日期"
      t.string :newBike, comment: "是否新车"
      t.string :insuranceNum, comment: "保险单号"
      t.string :antiTheftCode, comment: "防盗码"
      t.string :industry, comment: "行业车辆"
      t.string :motorNum, comment: "电动机号"
      t.string :promise, comment: "来历承诺"
      t.string :modelNum, comment: "厂牌型号"
      t.string :site, comment: "所在站点"
      t.string :city, comment: "城市"
      t.timestamps
    end
  end
end
